import xlwings as xw

table = xw.Book('E:/excel操作/库尔勒银行通讯录.xls')  # 建立连接

sht = table.sheets('乌鲁木齐分行')

print('工作表绝对路径', table.fullname)

print('工作表名字', sht.name)

a1v = sht.range('b').raw_value
print('a1:', a1v)

